drop table if exists d_enp_ppm_ismg_mwwg_sp_h ;
create table if not exists d_enp_ppm_ismg_mwwg_sp_h_#{PARTITION_DATE}
 (
ismpi01    datetime ,
ismpi02    datetime ,
ismpi03    varchar(128) ,
ismpi04    varchar(64) ,
ismpi05    varchar(64) ,
ismpi06    varchar(64) ,
ismpi07    varchar(64) ,
ismpi08    varchar(64) ,
ismpi09    bigint ,
ismpi10    bigint ,
ismpi11    double ,
ismpi12    bigint ,
ismpi13    bigint ,
ismpi14    bigint ,
ismpi15    bigint ,
ismpi16    double ,
ismpi17    bigint ,
ismpi18    bigint ,
ismpi19    double ,
ismpi20    bigint ,
ismpi21    bigint ,
ismpi22    double ,
ismpi23    double ,
ismpi24    bigint ,
ismpi25    bigint ,
ismpi26    bigint ,
ismpi27    bigint ,
ismpi28    double ,
ismpi29    varchar(10)
)   compress(5, 5)  nolock ;